Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPO40002
Product: Purchase Order Enhancements (2277)
Series:
Display Name: CPOP_Setup_LINE
Physical Name: CPO40002
Technical Name: CPOP_Setup_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['CPOP_Setup_LINE'].CMPANYID AS 'CPOP_Setup_LINE-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CPO40002 AS ['CPOP_Setup_LINE']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CPOP_Setup_LINE'].CMPANYID = ['Company Master'].CMPANYID2 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['CPOP_Setup_LINE'].BUDGETID AS 'CPOP_Setup_LINE-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
CPO40002 AS ['CPOP_Setup_LINE']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['CPOP_Setup_LINE'].BUDGETID = ['Budget Master'].BUDGETID3 YEAR1 Year Integer Year 4